| Column | Data Type | Nullable | Default | Description |
| TIME_ID | DATE(7) | not null | | primary key; day date, finest granularity, CORRECT ORDER |
| DAY_NAME | VARCHAR2(9) | not null | | Monday to Sunday, repeating |
| DAY_NUMBER_IN_WEEK | NUMBER(1, 0) | not null | | 1 to 7, repeating |
| DAY_NUMBER_IN_MONTH | NUMBER(2, 0) | not null | | 1 to 31, repeating |
| CALENDAR_WEEK_NUMBER | NUMBER(2, 0) | not null | | 1 to 53, repeating |
| FISCAL_WEEK_NUMBER | NUMBER(2, 0) | not null | | 1 to 53, repeating |
| WEEK_ENDING_DAY | DATE(7) | not null | | date of last day in week, CORRECT ORDER |
| WEEK_ENDING_DAY_ID | NUMBER | not null | | |
| CALENDAR_MONTH_NUMBER | NUMBER(2, 0) | not null | | 1 to 12, repeating |
| FISCAL_MONTH_NUMBER | NUMBER(2, 0) | not null | | 1 to 12, repeating |
| CALENDAR_MONTH_DESC | VARCHAR2(8) | not null | | e.g. 1998-01, CORRECT ORDER |
| CALENDAR_MONTH_ID | NUMBER | not null | | |
| FISCAL_MONTH_DESC | VARCHAR2(8) | not null | | e.g. 1998-01, CORRECT ORDER |
| FISCAL_MONTH_ID | NUMBER | not null | | |
| DAYS_IN_CAL_MONTH | NUMBER | not null | | e.g. 28,31, repeating |
| DAYS_IN_FIS_MONTH | NUMBER | not null | | e.g. 25,32, repeating |
| END_OF_CAL_MONTH | DATE(7) | not null | | last day of calendar month |
| END_OF_FIS_MONTH | DATE(7) | not null | | last day of fiscal month |
| CALENDAR_MONTH_NAME | VARCHAR2(9) | not null | | January to December, repeating |
| FISCAL_MONTH_NAME | VARCHAR2(9) | not null | | January to December, repeating |
| CALENDAR_QUARTER_DESC | CHAR(7) | not null | | e.g. 1998-Q1, CORRECT ORDER |
| CALENDAR_QUARTER_ID | NUMBER | not null | | |
| FISCAL_QUARTER_DESC | CHAR(7) | not null | | e.g. 1999-Q3, CORRECT ORDER |
| FISCAL_QUARTER_ID | NUMBER | not null | | |
| DAYS_IN_CAL_QUARTER | NUMBER | not null | | e.g. 88,90, repeating |
| DAYS_IN_FIS_QUARTER | NUMBER | not null | | e.g. 88,90, repeating |
| END_OF_CAL_QUARTER | DATE(7) | not null | | last day of calendar quarter |
| END_OF_FIS_QUARTER | DATE(7) | not null | | last day of fiscal quarter |
| CALENDAR_QUARTER_NUMBER | NUMBER(1, 0) | not null | | 1 to 4, repeating |
| FISCAL_QUARTER_NUMBER | NUMBER(1, 0) | not null | | 1 to 4, repeating |
| CALENDAR_YEAR | NUMBER(4, 0) | not null | | e.g. 1999, CORRECT ORDER |
| CALENDAR_YEAR_ID | NUMBER | not null | | |
| FISCAL_YEAR | NUMBER(4, 0) | not null | | e.g. 1999, CORRECT ORDER |
| FISCAL_YEAR_ID | NUMBER | not null | | |
| DAYS_IN_CAL_YEAR | NUMBER | not null | | 365,366 repeating |
| DAYS_IN_FIS_YEAR | NUMBER | not null | | e.g. 355,364, repeating |
| END_OF_CAL_YEAR | DATE(7) | not null | | last day of cal year |
| END_OF_FIS_YEAR | DATE(7) | not null | | last day of fiscal year |
| Check Constraint | Expression | Description |
| SYS_C005088 | "TIME_ID" IS NOT NULL | |
| SYS_C005089 | "DAY_NAME" IS NOT NULL | |
| SYS_C005090 | "DAY_NUMBER_IN_WEEK" IS NOT NULL | |
| SYS_C005091 | "DAY_NUMBER_IN_MONTH" IS NOT NULL | |
| SYS_C005092 | "CALENDAR_WEEK_NUMBER" IS NOT NULL | |
| SYS_C005093 | "FISCAL_WEEK_NUMBER" IS NOT NULL | |
| SYS_C005094 | "WEEK_ENDING_DAY" IS NOT NULL | |
| SYS_C005095 | "WEEK_ENDING_DAY_ID" IS NOT NULL | |
| SYS_C005096 | "CALENDAR_MONTH_NUMBER" IS NOT NULL | |
| SYS_C005097 | "FISCAL_MONTH_NUMBER" IS NOT NULL | |
| SYS_C005098 | "CALENDAR_MONTH_DESC" IS NOT NULL | |
| SYS_C005099 | "CALENDAR_MONTH_ID" IS NOT NULL | |
| SYS_C005100 | "FISCAL_MONTH_DESC" IS NOT NULL | |
| SYS_C005101 | "FISCAL_MONTH_ID" IS NOT NULL | |
| SYS_C005102 | "DAYS_IN_CAL_MONTH" IS NOT NULL | |
| SYS_C005103 | "DAYS_IN_FIS_MONTH" IS NOT NULL | |
| SYS_C005104 | "END_OF_CAL_MONTH" IS NOT NULL | |
| SYS_C005105 | "END_OF_FIS_MONTH" IS NOT NULL | |
| SYS_C005106 | "CALENDAR_MONTH_NAME" IS NOT NULL | |
| SYS_C005107 | "FISCAL_MONTH_NAME" IS NOT NULL | |
| SYS_C005108 | "CALENDAR_QUARTER_DESC" IS NOT NULL | |
| SYS_C005109 | "CALENDAR_QUARTER_ID" IS NOT NULL | |
| SYS_C005110 | "FISCAL_QUARTER_DESC" IS NOT NULL | |
| SYS_C005111 | "FISCAL_QUARTER_ID" IS NOT NULL | |
| SYS_C005112 | "DAYS_IN_CAL_QUARTER" IS NOT NULL | |
| SYS_C005113 | "DAYS_IN_FIS_QUARTER" IS NOT NULL | |
| SYS_C005114 | "END_OF_CAL_QUARTER" IS NOT NULL | |
| SYS_C005115 | "END_OF_FIS_QUARTER" IS NOT NULL | |
| SYS_C005116 | "CALENDAR_QUARTER_NUMBER" IS NOT NULL | |
| SYS_C005117 | "FISCAL_QUARTER_NUMBER" IS NOT NULL | |
| SYS_C005118 | "CALENDAR_YEAR" IS NOT NULL | |
| SYS_C005119 | "CALENDAR_YEAR_ID" IS NOT NULL | |
| SYS_C005120 | "FISCAL_YEAR" IS NOT NULL | |
| SYS_C005121 | "FISCAL_YEAR_ID" IS NOT NULL | |
| SYS_C005122 | "DAYS_IN_CAL_YEAR" IS NOT NULL | |
| SYS_C005123 | "DAYS_IN_FIS_YEAR" IS NOT NULL | |
| SYS_C005124 | "END_OF_CAL_YEAR" IS NOT NULL | |
| SYS_C005125 | "END_OF_FIS_YEAR" IS NOT NULL | |